Filter:
0.Create project1.Create new column Serial Number based on column Sl. No. by filling 26372 rows with grel:"00000"[0,5-row.index.length()]+row.index2.Remove column Sl. No.3.Text transform on 26372 cells in column Finance_Year: grel:value[0,4]4.Mass edit 3937 cells in column Finance_Year5.Mass edit 10124 cells in column Finance_Year6.Mass edit 11828 cells in column Finance_Year7.Mass edit 483 cells in column Finance_Year8.Text transform on 26372 cells in column Finance_Year: value.toDate()9.Mass edit 1 cells in column Ownership Type10.Mass edit 1 cells in column Ownership Type11.Mass edit 6 cells in column Ownership Type12.Mass edit 70 cells in column Ownership Type13.Mass edit 22 cells in column Ownership Type14.Create new column Inkorporation Year based on column Company Name by filling 26372 rows with grel:cell.cross("corporationyear", "Company Name").cells["IncorporationYear"].value[0]15.Remove column Incorporation Year16.Move column Inkorporation Year to position 317.Move column Inkorporation Year to position 418.Remove 296 rows19.Remove 155 rows20.Remove 39 rows21.Remove 4 rows22.Remove 16 rows23.Remove 2 rows24.Mass edit 5071 cells in column Sales-Total Revenue25.Mass edit 6398 cells in column Sales-Total Revenue26.Mass edit 1431 cells in column DICOP -Direct Indirect Cost of Production27.Mass edit 7119 cells in column DICOP -Direct Indirect Cost of Production28.Mass edit 522 cells in column VAE-Value Added Expenditure29.Mass edit 1977 cells in column VAE-Value Added Expenditure30.Text transform on 23114 cells in column OP-Operating Profit: grel:value.toString("%.0f")31.Mass edit 5207 cells in column OP-Operating Profit32.Mass edit 1718 cells in column OP-Operating Profit33.Mass edit 5207 cells in column OP-Operating Profit34.Text transform on 24090 cells in column TC-Total Cost: grel:value[0,7]35.Mass edit 625 cells in column TC-Total Cost36.Mass edit 1770 cells in column TC-Total Cost37.Text transform on 20110 cells in column GP-Gross Profit: grel:value.toString("%.0f")38.Mass edit 1029 cells in column GP-Gross Profit39.Mass edit 4121 cells in column GP-Gross Profit40.Text transform on 19462 cells in column Arms Length Price/Transfer Price Indicator: grel:value[0,7]41.Mass edit 254 cells in column Arms Length Price/Transfer Price Indicator42.Mass edit 254 cells in column Arms Length Price/Transfer Price Indicator43.Mass edit 6398 cells in column Arms Length Price/Transfer Price Indicator44.Text transform on 8037 cells in column Other Operating Income/Sales: grel:value.toString("%.0f")45.Text transform on 15377 cells in column Advertising & Marketing Sales: grel:value.toString("%.0f")46.Mass edit 3 cells in column Advertising & Marketing Sales47.Mass edit 5 cells in column Other Operating Income/Sales48.Mass edit 13484 cells in column Other Operating Income/Sales49.Text transform on 21521 cells in column Other Operating Income/Sales: value.toNumber()50.Text transform on 15377 cells in column Advertising & Marketing Sales: value.toNumber()51.Create new column Additional_Cost based on column Advertising & Marketing Sales by filling 25860 rows with grel:cells['Other Operating Income/Sales'].value + cells['Advertising & Marketing Sales'].value52.Text transform on 25860 cells in column Additional_Cost: value.toString()
'
25860 rows
Extensions: Wikidata
All
Serial Number
Company Name
Finance_Year
Ownership Type
Inkorporation Year
Sales-Total Revenue
DICOP -Direct Indirect Cost of Production
VAE-Value Added Expenditure
OP-Operating Profit
TC-Total Cost
GP-Gross Profit
Arms Length Price/Transfer Price Indicator
Other Operating Income/Sales
Advertising & Marketing Sales
Additional_Cost
FinalResults
  
1.
00000
 20 Microns Ltd.
 2014-03-31T00:00:00Z
 Indian Private Sector
 1987
 290.96
145.75
130.24
 15
 275.99
 145
 0.05145
false
  
2.
 00001
 2020 Imaging India Ltd.
 2014-03-31T00:00:00Z
 Indian Private Sector
 2005
 0.66
0.71
0.51
 -1
 1.22
 -0.8484
false
  
3.
 00002
 21St Century Constructions Ltd.
2014-03-31T00:00:00Z
 Indian Private Sector
 1985
 0.00
0.00
0.05
 0.05
0.00000
false
  
4.
00003
3 F Industries Ltd.
 2014-03-31T00:00:00Z
 Indian Private Sector
 1960
 1125.62
 904.24
184.6
 37
 1088.84
221
0.03267
false
  
5.
 00004
 3D P L M Software Solutions Ltd.
 2014-03-31T00:00:00Z
 Indian Private Sector
 2001
 308.56
 0.28
 241.81
 66
 242.09
 308
 0.21542
true
  
6.
00005
 3I Infotech B P O Ltd.
2014-03-31T00:00:00Z
 Indian Private Sector
 1990
 63.99
 0.05
 62.88
 62.93
 64
0.01656
true
  
7.
 00006
3I Infotech Consultancy Services Ltd.
 2014-03-31T00:00:00Z
 Indian Private Sector
 2007
 62.04
0.34
 59.49
59.8300
62
0.03562
true
  
8.
 00007
 3I Infotech Ltd.
2014-03-31T00:00:00Z
 Indian Private Sector
 1993
 408.44
 2.33
539.88
-134
542.21
406
 -0.3275
true
  
9.
 00008
3I Infotech Trusteeship Services Ltd.
2014-03-31T00:00:00Z
 Indian Private Sector
 2001
 2.11
 0.00
 1.7
1.7
 0.19431
true
  
10.
 00009
3M India Ltd.
2014-03-31T00:00:00Z
 Foreign Private Sector
1987
1750.84
1093.32
 580.43
 77
1673.75
 658
 0.04403
 false
  
11.
 00010
 52 Weeks Entertainment Ltd.
2014-03-31T00:00:00Z
Indian Private Sector
1993
0.00
0.02
1.71
 -2
1.73
 0.00000
 false
  
12.
00011
 7Seas Entertainment Ltd.
2014-03-31T00:00:00Z
Indian Private Sector
 1991
1.73
 0.03
 5.73
 -4
 5.76000
 -2.3294
 true
  
13.
 00012
 8K Miles Software Services Ltd.
 2014-03-31T00:00:00Z
Indian Private Sector
1993
 7.22
 0.00
 6.31
 6.31
 0.12603
 true
  
14.
 00013
 A 2 Z Infra Engg. Ltd.
 2014-03-31T00:00:00Z
 Indian Private Sector
 2002
336.35
 214.03
 232.34
 -110
 446.37
 122
 -0.3270
 true
  
15.
00014
 A 2 Z Infraservices Ltd.
 2014-03-31T00:00:00Z
 Indian Private Sector
 2008
247.98
 0.03
 232.65
 15
 232.68
 248
 0.06169
 true
  
16.
 00015
 A 2 Z Infrastructure Ltd.
 2014-03-31T00:00:00Z
 Indian Private Sector
 2007
47.46
0.73
 56.43
 -10
 57.16
 47
 -0.2043
 true
  
17.
00016
A 2 Z Powercom Ltd.
 2014-03-31T00:00:00Z
 Indian Private Sector
2008
0.00
0.00
 0.52
 -1
 0.52
 0.00000
 false
  
18.
 00017
 A 2 Z Powertech Ltd.
 2014-03-31T00:00:00Z
 Indian Private Sector
 2008
 1.1
 0.63
 0.33
 0.96
 0.12727
 false
  
19.
 00019
 A 2 Z Waste Mgmt. (Merrut) Pvt. Ltd.
 2014-03-31T00:00:00Z
 Indian Private Sector
 2009
 0.39
 0.00
 1.55
 -1
 1.55
 -2.9743
 false
  
20.
 00020
 A 2 Z Waste Mgmt. (Nainital) Pvt. Ltd.
 2014-03-31T00:00:00Z
 Indian Private Sector
 2010
 0.83
 0.00
 0.89
 0.89
 -0.0722
 false
  
21.
 00021
 A A P Infrastructure Ltd.
 2014-03-31T00:00:00Z
 Indian Private Sector
 2002
 17.4
 0.00
 9.7
 9.7
 17
 0.44252
 true
  
22.
 00022
 A B B Global Inds. & Services Pvt. Ltd.
 2013-03-31T00:00:00Z
 Foreign Private Sector
 2001
 572.15
 7.1
 467.07
 98
 474.17
 565
 0.17124
 true
  
23.
 00023
 A B B India Ltd.
 2013-03-31T00:00:00Z
 Foreign Private Sector
 1949
 7721.99
 5000.23
 2343.58
 378
 7343.80
 2722
 0.04897
 false
  
24.
 00024
 A B Bank Ltd.
 2014-03-31T00:00:00Z
 Foreign Private Sector
 1996
 21.84
 0.00
 17.24
 17.24
 22
 0.21062
 false
  
25.
 00025
 A B C Bearings Ltd.
 2014-03-31T00:00:00Z
 Indian Private Sector
 1961
 146.28
 81.03
 54.75
 11
 135.78
 65
 0.07178
 false
  
26.
 00026
 A B C Gas (International) Ltd.
 2014-03-31T00:00:00Z
 Indian Private Sector
 1980
 2.68
 2.1
 0.46
 2.56
 0.04477
 false
  
27.
 00027
 A B C India Ltd.
 2014-03-31T00:00:00Z
 Indian Private Sector
 1972
 160.64
 51.23
 117.28
 -8
 168.51
 109
 -0.0489
 true
  
28.
 00028
 A B Corp Ltd.
 2013-03-31T00:00:00Z
 Indian Private Sector
 1988
 21.22
 5.1
 8.14
 13.24
 16
 0.37606
 true
  
29.
 00029
 A B G Infralogistics Ltd.
 2014-03-31T00:00:00Z
 Indian Private Sector
 1983
 74.6
 1.94
 71.26
 73.2
 73
 0.01876
 true
  
30.
 00030
 A B G Kandla Container Terminal Ltd.
 2014-03-31T00:00:00Z
 Indian Private Sector
 2006
 5.44
 0.21
 18.63
 -13
 18.84
 -2.4632
 true
  
31.
 00031
 A B G Ports Ltd.
 2014-03-31T00:00:00Z
 Indian Private Sector
 2008
 0.1
 0.00
 0.37
 0.37
 -2.7
 true
  
32.
 00032
 A B G Shipyard Ltd.
 2014-03-31T00:00:00Z
 Indian Private Sector
 1985
 1623.9
 203.64
 1015.09
 405
 1218.73
 1420
 0.24950
 false
  
33.
 00033
 A B G Turnkey Pvt. Ltd.
 2014-03-31T00:00:00Z
 Indian Private Sector
 2009
 0.00
 0.00
 0.00
 0.00
 0.00000
 false
  
34.
 00034
 A B Hotels Ltd.
 2014-03-31T00:00:00Z
 Indian Private Sector
 1990
 99.25
 92.47
 94.47
 97
 0.04816
 true
  
35.
 00035
 A B I-Showatech (India) Ltd.
 2014-03-31T00:00:00Z
 Indian Private Sector
 1991
 328.79
 151.43
 128.16
 49
 279.590
 177
 0.14963
 false
  
36.
 00036
 A B M International Ltd.
 2014-03-31T00:00:00Z
 Indian Private Sector
 1983
 167.26
 166.77
 1.31
 -1
 168.08
 -0.0049
 false
  
37.
 00037
 A B M Knowledgeware Ltd.
 2014-03-31T00:00:00Z
 Indian Private Sector
 1993
 74.18
 0.68
 52.99
 21
 53.67
 74
 0.27648
 true
  
38.
 00038
 A B Medical Centres Ltd.
 2014-03-31T00:00:00Z
 Indian Private Sector
 1974
 -0.01
 0.00
 0.05
 0.05
 false
  
39.
 00039
 A B N Intercorp Ltd.
 2014-03-31T00:00:00Z
 Indian Private Sector
 2005
 0.05
 0.00
 0.1
 0.1
 -1
 true
  
40.
 00040
 A B N L Investment Ltd.
 2014-03-31T00:00:00Z
 Indian Private Sector
 1994
 1.94
 0.01
 0.54
 0.55
 0.71649
 false
  
41.
 00042
 A B P Realty Advisors Pvt. Ltd.
 2014-03-31T00:00:00Z
 Indian Private Sector
 2007
 0.00
 0.00
 0.01
 0.01
 0.00000
 false
  
42.
 00043
 A C C Ltd.
 2013-03-31T00:00:00Z
 Foreign Private Sector
 1936
 11041.62
 2698.74
 7355.92
 987
 10054.6
 8343
 0.08938
 false
  
43.
 00044
 A C C Mineral Resources Ltd.
 2013-03-31T00:00:00Z
 Foreign Private Sector
 1930
 0.00
 0.00
 0.06
 0.06
 0.00000
 false
  
44.
 00045
 A C E Derivatives & Commodity Exchange Ltd.
 2014-03-31T00:00:00Z
 Indian Private Sector
 1956
 1.23
 0.57
 19.71
 -19
 20.28
 -15.487
 false
  
45.
 00046
 A C E Designers Ltd.
 2014-03-31T00:00:00Z
 Indian Private Sector
 1986
 334.95
 223.32
 88.79
 23
 312.11
 112
 0.06818
 false
  
46.
 00047
 A C E Edutrend Ltd.
 2014-03-31T00:00:00Z
 Indian Private Sector
 1993
 23.07
 1.43
 20.34
 21.77
 22
 0.05635
 true
  
47.
 00048
 A C E Exports Ltd.
 2014-03-31T00:00:00Z
 Indian Private Sector
 1990
 11.47
 8.2
 11.2
 0.02353
 false
  
48.
 00049
 A C E Stonecraft Ltd.
 2014-03-31T00:00:00Z
 Indian Private Sector
 1992
 0.00
 0.02
 0.11
 0.13
 0.00000
 false
  
49.
 00050
 A C E Tours Worldwide Ltd.
 2014-03-31T00:00:00Z
 Indian Private Sector
 2007
 15.45
 12.72
 2.26
 14.98
 0.03042
 true
  
50.
 00051
 A C I Infocom Ltd.
 2014-03-31T00:00:00Z
 Indian Private Sector
 1982
 0.00
 -1.09
 1.36
 0.27
 0.00000
 false